/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package Models;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 *
 * @author sio
 */
public class Connect {
    private static Connection con = null;
    private static Connection open() 
    {
    try {
    Class.forName("org.postgresql.Driver");
    } catch (ClassNotFoundException e)
    {
        System.out.println("Pilote mal installe..." + e);
    }
    try {
    con= DriverManager.getConnection("jdbc:postgresql://lucie/medecin", "nsehnoun", "linux");
    } catch (SQLException e)
    {
        System.out.println("Erreur SQL : " + e);
    }
    return con;
    }
    
    public static Connection get() 
    {
    if (con == null)
    {
    con=Connect.open();
    }
    return con;
    }
    public static void close() 
    {
    try 
    {
    con.close();
    } catch(SQLException e) 
    {
        System.out.println("Erreur SQL : " + e);
    }
    }
}
